﻿CREATE TABLE [flcr].[RESOURCE_DEVICE_XREF] (
    [RESOURCE_DEVICE_XREF_ID] INT           NOT NULL,
    [AUDIT_USER]              VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]              DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]           INT           NOT NULL,
    [AUDIT_MOD_USER]          VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]          DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]       INT           NOT NULL,
    [ACTIVE_FLG]              BIT           NOT NULL,
    [RESOURCE_ID]             INT           NOT NULL,
    [DEVICE_ID]               INT           NOT NULL,
    [SUPPORT_ROLE_ID]         INT           NOT NULL
);

